Previous Topic

Next Topic

Example: Find purchases by amount and date

This query extracts customers who have purchased more than $100 within a specific date range.

  1. Browse to IQA.
  2. Select Query from the drop-down list and select New.
  3. Select sources:
    1. Browse to the Common folder containing business objects.
    2. Select the Contact and CsActivity business objects.
    3. Make sure the default join in the Relations area is Contact.Id Equals CsActivity.Id.
  4. Define the filtering rules:
    1. Select the Filters tab.
    2. Filter on CsActivity.ActivityType.
      • Mode: Basic
      • Property: CsActivity.ActivityType
      • Comparison: Equals
      • Value: ORDER
    3. Add the filter.
    4. Filter on CsActivity.TransactionDate.
      • Property: CsActivity.TransactionDate
      • Comparison: Between
      • Value: "1/1/1995","12/31/1995"
    5. Add the filter.
    6. Filter on CsActivity.Amount.
      • Property: CsActivity.Amount
      • Comparison: Greater
      • Value: 100
    7. Add the filter.
  5. Define the columns to display in the output:
    1. Select the Display tab.
    2. Select the following columns:
      • Contact.ID
      • CsActivity.Amount

        Note: A default list of columns displays when you select the Display tab. Deselect the columns you do not need. If a column you need is not in the default list, select All from the View drop-down list and scroll down the page to select the desired column.

    3. Using the Order drop-down list, assign:
      • Contact.Id Order 1
      • CsActivity.Amount Order 2
  6. Specify the sorting priority:
    1. Select the Sorting tab.
    2. Sort the results by Contact.Id.
    3. Add the selection.
  7. Save your settings.
  8. Run the query.

See Also

Query Examples

Example: Find recipients for e-mail

Example: Find current registrants

Example: Find registered members by city

Example: Find members by company and state

Example: Find members by state or join date

Example: Find total number of pledges by amount


ASI logo 10.6 Production Release. Updated 7/27/2006 3:53:05 PM
© 2009 by Advanced Solutions International, Inc. All rights reserved.